2013-01-10- 5579.600 - Spec - ELT Reports(Service Level Report) #CrystalReportDevelopment
SPECIFICATIONS
5579.600 - ELT Reports (Service Level Report)
Requirement Summary
Design and development of Service level report using crystal report 2008.
Admin Info
Title
|
ELT reports(Service Level Report)
|
Requested By
|
Mark Harris
|
Spec Created By
|
Mallareddy D
|
Spec Created Date
|
02/22/2012
|
Spec QA by
|
Uday Kumar P
|
Objects
|
SSL
|
Document Status
|
Complete
|
References
Prior Tickets
None
Documents
Service Level 1.xlsx
Functional Requirement
02/21/2013 - Change in Requirement Gathered from Ashwin in IM.
1) Need to remove the sub-reports used in Group1 section because in drill down, group hierarchy shows some blank groups.
02/162013 - Regarding Top N - Requirement gathered from Ashwin through IM.
1) Top N Condition has to apply based on "Confirmed Quantity Current Year to Date".
02/15/2013 - Regarding including the Consolidation file - Requirement gathered from Ashwin through IM.
1) Need to include the Consolidation files for the report to get the description defined by New Era.
02/6/2013 - Service level sheet received from Mark and Requirement gathered from Ashwin in call.
1) All 6 reports are merged into single report.
2) Need to show Corporate information in Report.
3) Need to show Corporate and corresponding Region information in the main report.
4) When the user clicks on any Region in Group header of the report, it need to show the corresponding region.
Top N Customers, Top N Silhouettes, Top N Collections, Top N Licenses, All Customer Segments and Product Mix for Head wear, Apparel and Accessories.
5) When the user drills down into the region level, in Group Tree need to show Sales org and if the user click on any sales org the report need to drill down to the Corresponding Sales org and Top N Customers, Top N Silhouettes, Top N Collections, Top N Licenses, All Customer Segments and Product Mix for Head wear, Apparel and Accessories for the Selected Sales Org in new Tab.
6) Need to Provide parameters for Top N Customers and Top N Silhouettes, Top N Collections and Top N Licenses.
02/5/2013 - Service level sheet received from Ashwin and requirements gathered from Ashwin in call.
1) Fields need to show :
Ordered Fill Rate YTD This Year, Ordered Fill Rate YTD Last Year, Ordered Fill Rate MTD This Year,Ordered Fill Rate MTD Last Year
Confirmed Fill Rate YTD This Year, Confirmed Fill Rate MTD This Year,Confirmed Fill Rate YTD Last Year, Confirmed Fill Rate MTD Last Year
Ordered Ontime YTD This Year, Ordered Ontime MTD This Year,Ordered Ontime YTD Last Year, Ordered Ontime MTD Last Year,
Confirmed Ontime YTD This Year, Confirmed Ontime MTD This Year, Confirmed Ontime YTD Last Year, Confirmed Ontime MTD Last Year,
Confirmed First Pass YTD This Year, Confirmed First Pass MTD This Year,Confirmed First Pass YTD Last Year, Confirmed First Pass MTD Last Year.
2) Need to develop 6 reports with the following grouping using the above fields:
Report 1 : Region > Product Mix (Headwear, Apparel and Accessories) > Sales Org.
Report 2 : Region > License (Top 5) > Sales Org.
Report 3 : Region > Silhouette (Top 5) > Sales Org.
Report 4 : Region > Customer Segment (All Grouped) > Sales Org.
Report 5 : Region > Customer (Top 10) > Sales Org.
Report 6 : Region > Collection (Top 5) > Sales Org.
Service Level 1.xlsx
Solution Summary
1. BEx Query Used : ZSDC_SSL_Q009.
2. This report has 2 groups with 10 subreports.
3. Group1 - Region and Group2 - Sales Org
Test Plan
SNo.
|
Test Scenario
|
Expected Results
|
1.
|
Report need to compare with BEx query
|
Values should be identical
|
Solution Details
1. Source for this report is BW BEx query ZSDC_SSL_Q009.
2. The report has 2 Groups with 10 Subreports.
3. Group1 - It is Grouped based on Region field (0SALESORG_REGION)
4. For Group 1 we used 5 subreports which names "License_Group1", "Silhouette_Group1", "ProductMix_Group1", "Customer_Grou1" and Customer Segment_Group1" all these subreports are used to show regions wise Customer()CUSTOMER), Customer Segment(0CUST_SALESZCUST_GR9), Silhouette(0MATERIALZ_SILH), Product Mix(0MATERIAL0MATL_GROUP) and License (0MATERIALZ_LICENSE).
5. Group 2 - It is Grouped based on Sales Org field (0SALESORG)
6. For Group 2 we used 5 subreports to show Sales Org wise Customer(0CUSTOMER), Customer Segment(0CUST_SALESZCUST_GR9), Silhouette(0MATERIALZ_SILH), Product Mix(0MATERIAL0MATL_GROUP) and License (0MATERIALZ_LICENSE).
Issues
None